Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | |
TableID (FK) | A unique retailer assigned identifier for a particular table, at which Customers sit to eat food purchased in a FoodServiceTransaction. | ID_TB | Identity | integer | Table(LO_TB) |
ProcessModeCode | A mnemonic code denoting how this SaleReturnLineItem is to be processed in the kitchen. Example values include: Normal, Expedite, Delay. | CD_PCS | Code4 | char(4) | |
DestinationTypeCode | A mnemonic code denoting where the food is being served. e.g. Other, DineIn, ToGo, DriveThru, Pickup, Delivery, Patio, Catering, Garden. | TY_DST | Code4 | char(4) | |
SalesMetricsCode | A mnemonic code denoting the type of SalesMetrics that this line item may be applied to. e.g. Suggested, Normal. | CD_SLS_MTC | Code4 | char(4) | |
DelayUntilDateTime | The date and time this line item should be ready for pickup by or delivery to the Customer. | DT_DLY_UNTL | DateTime | datetime | |